Skip to main content

SLAM_metadata_fields

Downloads detailed field definitions for all objects to table METADATA_FIELDS.

warning

The list of fields returned is subject to Salesforce permissions.

Parameters:

NameTypeDefaultDescription
@sObjectVARCHAR(120)NULLSpecific Salesforce object name to retrieve field metadata for. If NULL, retrieves fields for all objects
@exists_actionVARCHAR(20)NULLAction to take if the METADATA_FIELDS table already exists. If NULL, uses the value from SLAM_Settings.default_exists_action (defaulted to 'drop' during initial setup).

Valid options:
  • 'drop'
  • 'rename'
  • 'fail'

Usage Examples:

EXEC dbo.SLAM_metadata_fields

SELECT * FROM METADATA_FIELDS

With explicit exists action:

EXEC dbo.SLAM_metadata_fields
@exists_action = 'rename'